Excel multi-sheet with StartNewPage and Condition
We have a datasource with column (Column1) which can have N distict values, where N is unknown and can be any number.
In frx template we use GroupHeaderBand with Condition = Datasourse.Column1 and StartNewPage = true. When data is exported to PDF each group of values from Column1 is located at separate page. This works like expected.
When we use the same template to export to Excel 2007 file format, resulting workbook contains only one worksheet where groups come one after another.
But we expect that each group will reside on separate worksheet, resulting in N worksheets in one workbook. Is it possible?
In frx template we use GroupHeaderBand with Condition = Datasourse.Column1 and StartNewPage = true. When data is exported to PDF each group of values from Column1 is located at separate page. This works like expected.
When we use the same template to export to Excel 2007 file format, resulting workbook contains only one worksheet where groups come one after another.
But we expect that each group will reside on separate worksheet, resulting in N worksheets in one workbook. Is it possible?
Comments
http://www.fast-report.com/en/forum/?p=/discussion/14767
Rules:
- one report page = one sheet in a workbook
- one report page contains many printed paper sheet
- 'StartNewPage' property is only shifting to next printed paper sheet
the answer: do it programatically by cloning a report page to N report pages and export it to excel directly (not from report toolbar)
there is no easy way to achieve an advanced report